package com.crm.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.crm.domain.entity.Contract;
import com.github.pagehelper.Page;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.time.LocalDateTime;

public interface ContractMapper extends BaseMapper<Contract> {
    Page<Contract> selectByPage(@Param("createTime") LocalDateTime BbeginCreateTime, @Param("updateTime") LocalDateTime BendCreateTim, String name, String phone, String subject, String channel, String contractNo);

    @Select("select * from contract where id = #{id}")
    Contract selectContract(Long id);


}